IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'spTnotify_Update')
	BEGIN
		PRINT 'Dropping Procedure spTnotify_Update'
		DROP  Procedure  spTnotify_Update
	END

GO

PRINT 'Creating Procedure spTnotify_Update'
GO
Create Procedure dbo.spTnotify_Update
	( 	  
		@UniqueID int, 
		@msgtype char(8) = null, 
		@empno char(10) = null, 
		@tfileno char(20) = null, 
		@ILPno char(20) = null, 
		@msgtxt char(255) = null, 
		@fstatus char(10) = null, 
		@tdatetime DateTime = null
	)
AS
  /* 
    ------------------------------------------------------------------------------
    - Change History
    - --------------
    - Date          Description
    ------------------------------------------------------------------------------
    - 9/6/2007    Initial version Updated
    ------------------------------------------------------------------------------
  */

	-- Declare the required variables

	-- Update the required new record
	UPDATE Tnotify
	SET
		msgtype = @msgtype, 
		empno = @empno, 
		tfileno = @tfileno, 
		ILPno = @ILPno, 
		msgtxt = @msgtxt, 
		fstatus = @fstatus, 
		tdatetime = @tdatetime		
	WHERE UniqueID = @UniqueID

	-- Return to calling method
	RETURN
	
GO
